SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002876s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 571181 LIMIT 1 [ RunTime:0.003260s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 571181 [ RunTime:0.004606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449531,846930,252064,1018357,933307,964884,467619,331304,158975,1014753,345894,208396,130459,821,24275,499266,846789,715376,851054,131026,852272,351095,220025,649029,47934,507252,370981,341219,976945,684274,642391,578902,1009198,446509,636982,578619,286569,263181,657960,445364,728729,82924,34001,821817,464084,165059,433800,275746,490513,205052,469303,455366,718244,594822,81152,41953,337554,136329,230539,177747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 571181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 571181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]