SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465715 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465715 [ RunTime:0.004863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398348,296889,872002,331405,779965,995567,467664,389939,282832,370623,638027,114367,1032709,180060,398626,321375,247035,939816,890600,612612,284797,927858,314774,923180,78269,1047966,632809,836756,237872,150895,46289,1007432,989013,624021,417196,363497,553608,907908,10181,371380,415353,835068,679150,413914,364676,223066,430158,270958,108473,410390,612375,552921,10976,384350,842476,671634,490905,986032,736088,685889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]