SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4649 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4649 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301618,444783,877409,209485,147838,738095,697469,716283,321652,288243,448745,521157,769144,609673,134654,91512,86244,711650,727837,556943,596707,351026,221365,583655,678599,640425,627148,173559,761463,836716,439686,1047230,474515,888105,973511,495080,743118,441928,480184,848187,843814,248154,334002,292739,612568,375764,768726,855320,760184,636534,737443,780375,314481,254751,847903,393896,937743,991340,543391,888266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]