SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451961 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451961 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424088,306170,648743,45668,529642,177828,455711,731846,850534,338301,737011,507494,158396,529972,341976,213761,773620,862204,85325,341143,834238,290778,1036055,254092,343014,326651,178345,538366,377879,250789,948063,853162,485246,576258,920473,137899,784329,877644,920609,539956,252686,742697,526812,736551,688736,204524,164675,601750,304799,846916,773194,193426,599714,711613,898664,468766,682379,980806,88421,1023047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]