SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022099 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022099 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456455,752917,911573,705403,109480,806274,153420,545279,360080,655512,798485,761,967168,794638,50881,978451,739659,232555,1034061,715943,725532,301234,580147,927569,670600,714021,408513,413926,538831,944165,996037,578929,453569,294418,429224,299880,556095,625446,508440,1004902,660445,671341,686549,697456,795213,864349,420232,464427,183163,385260,1017837,1013362,851445,999924,899110,712645,977087,519518,919839,512504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]