SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416723 LIMIT 1 [ RunTime:0.000733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416723 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400815,108926,87653,616336,712018,369309,380531,898446,676400,22614,759339,210313,3605,802865,24380,344962,981620,207056,80107,272311,476630,902049,22981,807259,204228,622534,832035,34807,250788,554219,128742,370876,302207,880914,166135,786860,796073,145489,738300,245068,691922,363889,892173,676220,363570,472905,63455,345696,1036413,499715,824152,631540,770928,995222,578514,495143,999057,387498,999350,421893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]