SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036103 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036103 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325182,80798,487889,645934,212902,803640,467115,284083,211337,243669,412452,533175,357073,875648,697291,202662,670008,971880,1034787,872239,992841,775064,516245,349119,851245,100326,601921,39315,642044,254531,113824,226147,357887,424362,92078,521475,331893,434798,26221,127225,825022,298293,614643,631822,918298,917185,22735,724304,227128,426625,945941,1025811,1037179,633849,853466,541023,603675,326057,551744,351448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]