SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419423 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419423 [ RunTime:0.005927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128044,875798,794477,1024754,875690,907768,438533,155770,822967,46252,335152,484296,604341,674170,679601,312739,260322,95564,533988,595420,46885,303309,341572,773467,643233,978210,80371,934057,695055,1040730,303135,364712,668249,222508,601645,378279,917758,569198,299938,1030546,397525,277206,842029,786663,725053,192750,428914,835830,458103,607902,347420,6639,393367,732095,320713,377720,280192,606942,902745,347490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]