SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310189 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310189 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18928,1000187,1027922,892108,956859,746259,508132,671480,65217,1013734,982993,810188,530517,1045666,104545,1019129,846533,971547,661529,263341,710704,837603,209772,268885,858704,979511,687046,21843,397466,295083,312796,669522,1032099,965975,721718,478372,70854,492699,410096,607196,637802,336842,892979,265446,609952,155042,844206,181108,122284,918782,415783,882229,451066,930089,1028798,896745,702443,1007290,464859,519290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]