SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26151 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26151 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113009,87210,805535,783620,79347,549152,496401,962222,643104,47141,656206,720681,177899,12813,495371,662696,868933,233581,662870,74033,698,249527,209494,968884,377518,782407,673259,540467,905403,639864,171561,644979,254537,988110,983774,960852,1048533,509827,664235,937542,135835,454515,474363,731725,229675,73531,959856,551328,28040,583263,969883,879140,944179,794772,350645,298456,700455,160951,392766,119020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001596s ]