SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211187 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211187 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762491,861889,434024,1003900,721057,1044246,472690,396666,484304,118027,680569,886316,12765,225969,292862,949080,427003,730135,122833,33064,296790,683133,613752,208906,808341,120887,537719,155888,846656,990638,482265,867683,1020199,25600,117844,1039600,285215,340102,106177,641192,212835,579277,554759,594189,386230,113161,428342,769648,290316,424695,975180,92608,639205,802418,1007731,421924,919324,412124,417889,1044296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]