SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559711 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559711 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494052,847287,194274,585695,594340,1037125,680362,397519,882622,109767,995898,693965,560167,868752,814771,779516,338123,839756,15870,950002,574103,827997,161472,1756,63279,383161,730015,83476,725477,725976,868963,1040570,249335,29354,173721,945875,658471,1003083,7623,432802,610825,127726,126071,43599,290755,455262,571866,843144,859547,903309,793615,292348,24616,28015,1048783,683541,683800,986222,779163,907808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001758s ]