SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 712003 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 712003 [ RunTime:0.003957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390674,351100,868412,257128,474027,515015,920139,400741,201521,1028214,525992,141715,748550,457335,26100,635622,418280,680194,11349,59055,908327,483653,938525,777461,132976,123852,138733,313248,829322,595640,910650,73965,673047,69970,97937,1029851,68736,34864,53003,538014,209725,247230,582552,482917,971942,723166,898805,737239,634452,554913,1012666,357512,69508,513167,225353,14414,190004,942693,171235,743808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 712003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 712003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003500s ]