SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327994 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327994 [ RunTime:0.003099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010703,772000,911125,655230,913540,361832,274995,257884,928474,104650,448266,1044259,82272,526175,182964,736202,495355,131482,53174,69426,200163,259998,173320,696930,803854,884949,956294,936905,21633,877865,208958,75667,4353,935107,789039,676869,690223,259633,704053,771199,343910,515384,758603,954,668405,82524,341936,764924,46657,94795,629500,884037,161315,364600,330897,465338,327176,1029089,495449,173429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]