SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044270 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044270 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893626,881075,295213,105124,56517,523883,197059,876098,682866,105430,1011852,1030013,881243,526635,610990,690721,198128,510736,984764,497946,697229,125575,967369,879003,1023026,48510,543245,329658,764784,434003,589118,188137,223916,715175,59601,62609,593855,890167,121902,828662,626744,601397,792793,601568,837642,303759,939900,167308,677010,1011556,378793,874115,1030987,1012540,757154,1031056,419107,573505,281564,49249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]