SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541341 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541341 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980979,998095,539870,873547,544754,152097,233385,834659,344224,743711,807426,97534,325523,520917,66534,254481,842734,588306,626153,232041,581024,1018170,407181,133832,419040,810427,525907,877398,496717,754688,343080,96075,324612,820326,680043,540586,670535,571420,629969,29310,812360,39590,968066,547596,390198,513050,265607,1033102,940695,1021145,841394,37951,354856,126362,891824,8587,258910,697723,524525,320792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002196s ]