SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381952 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381952 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635509,552100,49108,116409,981683,110583,427043,1031582,108515,586407,50145,975114,572038,476162,901156,391312,450522,441882,815987,117915,916442,1021170,479081,53443,224332,517959,278710,229384,536742,50447,772250,308760,247544,515662,593199,425485,278080,555153,346480,139970,1010477,941788,265509,455080,577646,778900,993580,408518,764295,479954,107535,860574,714676,207875,45542,218332,733997,505793,961552,805408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]