SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030947 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030947 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10393,445311,409041,435956,80978,1030328,399421,936797,124684,962833,258765,629632,227199,720163,747458,884044,825977,312568,749779,358054,872943,106849,531436,336000,301530,302322,245849,425973,641221,512479,791391,460619,488569,113727,945455,856157,3922,344157,535019,394680,548119,785341,545342,626804,1024411,682231,864580,940748,703251,993437,640657,75098,477214,462810,65207,589705,42648,67769,967162,665110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]