SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686029 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686029 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312713,344431,661793,231812,921752,369790,323744,789151,713591,688142,434605,40638,386588,650984,778318,352869,329149,319104,42387,119915,65992,138305,592130,665095,125603,661512,670007,766397,1028530,914176,149010,693159,940636,756614,245728,723607,696720,134270,825918,723497,217135,137235,316566,648657,1013947,866731,725008,352716,831382,196823,923203,17062,946332,346333,30118,118412,210118,633546,575820,874591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]