SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38140 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38140 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340341,740470,446339,73835,547657,803466,961636,105385,506143,483610,826857,1028815,590699,261267,739148,569287,138776,691470,851505,176593,565449,14327,306080,222836,747176,744570,808683,933398,759565,513745,509133,31051,482047,792355,792282,79347,215243,786728,62633,478185,1013772,715965,244929,600081,252927,466485,493587,190967,688052,904925,315956,601341,751375,881393,99908,121955,800436,797107,636825,508599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]