SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033871 LIMIT 1 [ RunTime:0.002634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033871 [ RunTime:0.003135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836750,552708,899391,1023768,218331,408003,325120,584558,294779,924956,505236,72875,820272,1028657,957635,133336,999395,810199,680610,421237,107542,78807,196642,595509,462603,297683,208859,133385,427872,99165,605422,986930,34186,916261,877609,419839,321414,660607,550874,739708,194663,204808,450817,1028315,106200,108472,724811,523712,148039,303830,105567,1020450,440229,342186,316086,799828,470381,794005,272565,69142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]