SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467418 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467418 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422540,371652,213962,541814,119297,656446,588132,256348,524735,168529,11169,200727,419517,656221,1015814,599015,317388,368167,741938,745492,492738,231366,591368,335926,281177,338292,346080,429258,580369,662401,970590,982080,597774,644926,696885,121300,725162,920653,464401,426903,921799,870057,420798,27168,691853,87164,364654,380862,187224,583134,418633,553848,427221,1019806,506122,154028,155653,20121,879795,118092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]