SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333253 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333253 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884975,510761,467405,644271,677553,161076,651522,908018,665870,1019708,176931,445780,996948,797352,345914,54683,415280,998443,263760,323626,859518,932235,122731,188321,662919,1026675,154553,992735,28009,984789,87028,1048398,419432,418704,365942,294535,304603,926183,1014951,975278,649519,1048758,834074,204043,842271,813478,567928,536645,977201,237745,209226,805984,460305,478591,508010,994303,83063,26231,576421,566993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]