SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334950 LIMIT 1 [ RunTime:0.001874s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334950 [ RunTime:0.003108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608632,754685,658091,929864,1041428,764508,140666,321646,61544,434140,783640,1029837,431913,401200,336441,816047,774393,452001,20050,962014,500566,122486,921029,1040792,176934,237967,819459,265053,533765,348312,1026099,319816,907492,954421,942166,123445,202478,253434,251087,361584,56809,770243,448514,280026,889834,117774,478830,255751,651985,790294,865043,618726,813846,101417,1030347,232915,371284,300578,766708,449630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]