SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028655 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028655 [ RunTime:0.003153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931364,529803,168072,1013571,474418,1011751,99975,681332,610921,867301,95037,294527,1047229,122216,341243,731357,920756,94244,31819,996449,567839,295976,1012809,1020914,607887,479105,236135,81241,742430,632455,470948,428455,112738,175056,424649,588878,286251,589398,169508,217756,380558,49630,447842,970182,1018431,177301,124033,183257,921243,345581,65308,232816,319949,531872,281311,911640,536183,459343,33167,118213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]