SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295941 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295941 [ RunTime:0.004507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83634,242735,655647,198234,601690,712448,941798,784244,27991,396021,642769,278444,40500,614000,932163,88999,318321,21249,468563,182811,145042,269441,998245,442724,814760,628628,784593,40126,656884,385003,467589,404215,1013899,138232,474088,1039885,1034229,465682,967858,391123,478414,1029044,316712,403131,985753,119251,368121,159288,909335,364244,559682,755977,411299,807886,152278,739805,428463,384490,426289,447699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]