SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044776 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044776 [ RunTime:0.002840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620895,480479,617199,168819,81235,3650,522829,427325,527150,223625,370616,302053,120428,645507,431447,652837,234360,479491,786815,384565,143834,369311,67037,272101,971331,638390,426490,524981,964474,492119,534095,884734,361881,359580,420335,863006,1002500,236161,915265,517900,326253,481929,20360,560000,753712,156435,143895,623218,602253,539126,137519,656443,52094,697001,797067,752675,860026,442337,1036760,80844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]