SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200458 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200458 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453811,312196,63361,142545,906531,107348,67535,1034150,120291,924439,643083,369464,823883,674147,497405,837665,755884,900295,747993,707827,512788,699824,979291,626787,43980,447367,377833,84293,263033,92630,953969,954662,879412,467092,1046128,280662,967719,17976,668569,389998,891060,10732,456292,407568,785320,983569,429773,145681,305320,998437,452665,623707,157851,414992,18841,489444,490638,809936,922244,694502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]