SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386500 LIMIT 1 [ RunTime:0.002987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386500 [ RunTime:0.006736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676251,696995,688265,371120,29602,332357,302311,384990,213680,329356,813585,33308,599710,181458,268518,595998,1015031,128414,965262,102927,852633,188878,990297,801151,304674,162473,909422,961021,847561,59646,662594,737329,408735,152144,1040341,1016748,1002887,1023796,523408,570532,1032064,183515,701410,391958,1018338,682516,353203,611998,36457,873386,942735,872286,747812,485455,116471,591717,885959,949931,506973,404024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]