SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149817 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149817 [ RunTime:0.005103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105716,153927,959376,177780,678901,762815,924841,812208,662280,995416,870687,620630,103932,317881,926932,739223,353780,924815,895455,248460,810852,896115,89560,1017873,581870,164447,707626,65745,20089,767972,723704,451950,1011612,894082,164190,586934,502632,703389,126053,106810,614350,417780,426686,580079,987821,782425,1043660,945935,359572,543181,168129,484445,863957,850152,169889,45507,993147,31395,393380,1018856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]