SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40212 LIMIT 1 [ RunTime:0.003325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40212 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316079,671928,335514,1011207,121524,625083,560479,137646,975508,589084,34289,372947,788359,304218,35107,890199,736559,811297,213126,641597,1036237,602925,318919,229275,967911,377847,130221,863078,216765,287494,883343,751169,284262,1015064,1006360,524913,1028894,252906,828020,691400,493115,681248,107793,1009714,220309,703013,204158,735862,232880,815439,646874,696475,410763,146935,492989,158482,141963,313658,42463,163195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]