SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020876 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020876 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852965,815630,575053,385949,343591,386209,590923,996060,373841,929089,582306,443593,1027533,725011,317669,168953,617550,189372,703229,220350,585227,659890,453497,348395,187017,879688,227004,611887,928876,553855,565598,24389,42567,716972,628214,482474,436712,402227,518549,93597,86987,52594,651510,511952,759775,889371,540541,264941,324320,627950,982402,136438,195169,635455,781342,575182,969433,854551,871078,132034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]