SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 675400 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 675400 [ RunTime:0.005802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536555,105905,491274,1045166,593469,337439,290974,587253,303212,596987,1045025,709704,877268,271630,683857,685772,912483,269985,20000,195202,847308,636558,831740,270832,327751,341133,671730,407117,4550,256394,716238,538035,237378,843709,1048511,421819,662610,1008068,921544,992684,485339,123585,1024011,300061,853420,590996,113050,36796,1044225,996254,103600,824692,779251,421423,299726,757630,32195,424423,981432,163232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 675400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 675400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]