SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419508 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419508 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860195,656399,920152,112478,534774,562010,825256,805380,587296,568437,90292,181648,113780,896373,529138,168111,417220,212156,666027,634807,696403,116466,710943,288222,637721,202481,586777,735216,653363,603763,554298,202612,653767,599169,992951,702324,275344,55770,1003328,96303,982637,23442,216776,433493,1048219,985561,82583,225486,80166,371204,686688,949146,836254,400939,688184,405906,610045,173568,61845,979734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]