SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470432 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470432 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405764,710887,937183,12004,875926,1040080,899883,982916,312737,754771,380434,212101,890562,576821,300882,784243,370607,60849,751936,467330,886966,196788,49790,42825,362130,751627,97144,59607,343448,381270,715303,612490,758288,856019,292582,478478,534935,33768,1002872,762704,360743,693152,89260,958489,561080,437935,837859,10517,759477,1004087,206046,474644,210661,660492,1038257,733623,631540,463276,496350,552541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]