SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397844 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397844 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502724,41891,610904,993707,743380,414914,787014,1022832,1013477,665692,486948,830884,668725,566695,877992,661736,372327,912908,36867,100531,550011,454421,783689,1036172,602259,214948,524357,163098,990103,731602,144062,810014,256833,184363,522794,562488,193740,830127,745334,413053,310836,504460,415734,668944,32439,487481,685524,915887,870162,217446,363200,118111,602767,267129,690814,676802,651495,38863,409399,899474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000976s ]