SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508711 LIMIT 1 [ RunTime:0.002211s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508711 [ RunTime:0.003513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615205,42188,620507,206695,800041,1008982,122049,606872,1046632,863069,779901,364780,638463,724833,587924,929549,644850,1013476,970146,1002978,660293,25227,608995,1018877,760177,197814,880165,753897,992977,649817,822085,1015205,655016,509913,612235,584019,104879,557340,613984,447166,849846,967034,488113,476835,514962,463211,943761,141363,808709,1048769,105226,85205,449339,760240,732655,942961,812223,77780,298407,335020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]