SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685343 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685343 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703576,946857,382323,640206,802554,779677,239752,759707,1017167,469689,879221,460301,702063,834244,555052,418960,886646,236923,199601,973606,667850,281739,48677,1013537,1034749,694940,41095,454948,438041,547921,736186,336104,333493,540577,607118,195198,151812,267485,27218,330330,978818,886972,495474,847637,345519,581644,911594,225080,743299,19356,677606,427975,222972,204854,221543,392372,183013,400016,182606,547226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]