SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415273 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415273 [ RunTime:0.005223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412283,100467,246027,246804,910599,396806,1020135,450406,249111,756304,40407,290173,898880,559029,429229,180085,186133,554372,45049,775303,1034266,73559,928711,266575,714008,30853,199226,137131,843430,415849,317062,82040,465333,502615,202713,146885,943129,41554,193807,37362,1037396,881505,887997,800156,496061,790517,1002646,746050,1037974,802983,929834,847590,823506,551050,67169,986266,462807,987089,57365,195570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]