SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480165 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480165 [ RunTime:0.002706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610789,580069,900741,1037212,198330,827958,297455,647619,889354,799188,727110,1044209,443491,817173,734259,524212,897680,466768,764612,2728,500714,546756,241557,359660,282125,186664,720125,478021,228116,222544,573477,514967,710073,638244,850247,745130,563506,999503,804650,155686,1036499,294606,115105,217464,931034,46898,409763,1002258,5384,793975,175472,1015749,233256,168976,733476,177838,445980,34767,13538,730648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480165 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480165 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]