SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104826 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104826 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603617,381097,785469,1002540,941978,834545,478659,398316,688983,490914,1008453,342780,342030,213529,742185,822957,450365,258583,878499,978256,25362,544800,588465,741608,472689,14913,495136,325380,1035556,214896,751277,111970,962922,887929,144625,378582,1032954,572423,408291,327638,494161,320828,525190,121070,632117,310866,204523,206213,739250,341760,781455,925537,648931,85459,1046835,217267,950107,243863,581321,523209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]