SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305776 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305776 [ RunTime:0.002364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562668,136429,133380,157635,694374,784287,264151,201918,775195,890864,442996,838101,945924,798589,330068,17113,430541,943728,663179,356705,614037,547294,767342,201400,307967,153264,648377,473661,326843,519023,979816,833575,998248,292904,819188,327207,943131,704272,413089,77807,970568,346147,167556,282344,533402,36866,451500,289673,823233,971950,65322,594976,202673,807335,907832,751152,91312,241654,885529,1009365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]