SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568261 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568261 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491407,518719,572478,750831,450773,643879,238177,1037504,887848,651164,44101,268328,480191,163083,468078,473322,67647,923941,908457,126387,982317,427177,874912,525558,449882,297204,602925,1037846,887924,26270,475482,497121,947540,682365,281530,725459,693138,689654,31489,544180,24189,809841,331722,985071,14743,481327,77975,799840,674356,79033,786381,252806,765243,40016,1000128,797887,1009665,1042071,367053,307853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]