SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345004 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345004 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312063,746686,37215,747991,774234,579176,732746,570804,43305,210439,149553,742938,762482,63155,62792,48315,223736,666291,982521,471046,637115,329547,324353,87960,651035,423587,141067,712307,107819,241493,289599,631773,648000,73943,347400,386677,588738,528914,877748,151975,642423,179552,161769,669209,1008219,1041387,834634,490436,596185,750687,191497,280715,584335,73362,404558,906144,445457,414278,511378,145427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]