SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475805 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475805 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004023,373130,413167,38418,986135,673159,795360,547206,414974,783767,612762,966968,641956,479285,208646,542421,998994,958324,932706,721505,595127,445901,247762,303591,989963,556054,984145,559520,360960,884452,620863,196483,249182,1644,376124,779862,205466,830201,491967,193434,395025,1041193,755527,371613,959055,245929,45448,288563,964917,296196,265522,393048,984656,212049,717228,784155,313987,703030,76179,426230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]