SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426209 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426209 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308015,735354,533905,758217,456893,637691,31123,523981,257229,124424,222983,362387,898101,1019510,104257,591485,307783,562952,63166,87596,17567,626788,880144,835410,217365,454140,837943,506285,467893,976994,543988,1005548,232431,172848,635846,1007419,652442,447042,592713,345320,479832,249158,196100,453204,671907,494381,421487,268808,335014,363851,847537,822544,613144,556909,919589,418009,298331,342310,1023209,420488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]