SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040493 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040493 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312159,17153,913746,469773,354635,1005951,195670,891005,995106,273099,431462,571550,458417,683589,40106,561224,445164,495906,140270,26509,690989,670682,69351,333631,454506,812757,374348,759786,49849,676660,491046,64342,411618,403118,96766,312147,665795,452456,326326,819618,183898,194174,250029,500265,746317,977468,34471,732776,403935,758152,391018,35934,368609,200037,314298,736697,433080,1015494,901452,958527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]