SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150128 LIMIT 1 [ RunTime:0.001046s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150128 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503427,745307,846330,889367,58866,168360,153299,840118,341348,532451,921989,823948,1037636,829731,795406,959628,764494,927344,291797,213944,219988,455556,383005,209200,49112,234318,35696,683150,431742,455304,328786,1008596,291227,527101,392016,677502,12850,603032,28734,539713,625278,14652,851445,870313,199191,490223,1013005,454270,471066,30599,57419,548576,524060,388091,789004,228429,157760,769669,666477,625664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]