SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045260 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045260 [ RunTime:0.004290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723090,849559,90766,400140,793477,802405,271721,1042057,321990,751265,888090,361427,178400,237754,258477,770381,882883,387543,968591,28261,936178,534670,377209,599761,455791,613754,316552,790324,927725,990947,689284,622317,875511,493873,241849,713292,78169,968563,650918,563357,835527,187638,424320,885353,769904,586671,845445,886179,775067,870817,694338,135504,782871,901689,703135,220134,752351,709071,704142,798742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]