SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104381 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104381 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180835,244720,54517,207093,114558,943254,703856,306970,669021,869418,1043274,408423,177223,304929,408042,98736,703396,971822,138702,922061,798647,651996,672722,1006506,555876,418459,1040525,785761,797064,136931,696581,571093,310699,581963,143043,686961,498464,281744,515095,267865,892979,526449,560285,836810,524046,504925,986737,206839,213728,690062,708038,79319,472956,581282,568463,13956,292130,764577,482964,723085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]