SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105680 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105680 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748366,213114,15415,14135,647525,429076,971033,675353,136629,777598,192219,734231,283523,689329,405132,765297,774716,445544,255343,213872,513069,228536,20244,30965,223341,283342,930822,358483,928137,284548,270116,157670,185366,468578,310086,437647,318156,98609,7546,260343,929963,401843,696561,320303,503684,551033,911780,592120,923242,386477,13185,725789,732289,10535,274440,267038,771327,467030,575734,39430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.035420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004211s ]