SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509611 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509611 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120566,801640,749114,600685,443987,667833,10474,6117,571050,442264,169160,1015225,1019908,63607,592723,597329,909894,937082,972949,242949,53188,308884,100051,1044600,349119,428713,1028386,327815,279732,659669,215368,442537,424368,162976,841801,494184,560101,240481,804933,739872,474867,673644,177523,81470,76978,286672,431422,492747,839313,949276,737662,314224,30885,648160,862752,420253,945019,981263,843328,30313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]