SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4021 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4021 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663857,965719,148023,270867,39851,820672,180658,1030671,179456,730603,503601,199350,162288,94383,1022253,529347,1019534,908537,752457,905715,505496,571938,160172,896402,76761,387773,45165,954196,608996,1036095,972037,710442,984345,992424,243639,310019,483408,397060,946992,264686,858690,269102,322266,480814,726872,760127,57299,598282,246561,986395,381030,1004683,595994,155174,525358,869385,136180,1043647,537757,759742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]