SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53179 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53179 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257509,602051,450294,368973,954108,649508,196295,823088,759619,767148,775177,956065,244352,141481,663076,197327,69422,658518,659204,726357,242423,793864,511898,717779,1033240,624436,867369,122158,193545,110155,447233,701240,1040146,673009,62209,1041690,539128,863314,844212,635337,521252,921425,213185,883842,916901,485572,434719,394718,373823,827180,258628,769421,1014709,962406,540413,309989,511594,425065,581915,288468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]