SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414661 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414661 [ RunTime:0.004813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240188,559230,46583,1009685,1029242,418433,720590,772729,569846,1005157,235139,884093,870823,854629,483380,194088,751856,637664,1029459,462435,299819,511660,57857,340472,452086,296315,434596,129991,299177,909589,573169,1003386,53275,456295,923876,679774,783909,393459,728026,432647,406649,892216,389414,269021,629536,84235,1015449,182861,388448,910629,981478,961110,593985,285055,786883,73027,466452,943065,586625,379138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001075s ]