SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518025 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518025 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376678,481480,49649,227631,339383,128856,179078,591655,10442,64525,504481,352114,872345,470725,742775,181536,520813,634400,814082,123639,471634,738876,548143,156506,750838,935170,540417,828437,186498,541048,882949,488120,736595,154468,892379,813789,528415,548513,584678,564357,666296,327942,251685,64676,229049,200441,510486,685327,219972,200102,514908,1029158,129549,108444,737162,289594,623345,990402,86031,313201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]