SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54342 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54342 [ RunTime:0.005058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593658,751273,812331,730271,104852,72051,815218,750732,476258,199919,614563,795409,8298,264702,603340,739181,851186,307032,1014418,1039317,256440,162351,1005500,823534,305193,46576,342369,121597,48481,14474,13786,841990,459673,536849,315089,624103,173802,110284,262514,914615,1004810,677003,480376,690127,303344,434703,11840,149605,620860,351827,376392,311843,904917,195506,402085,851623,265354,373429,842653,833624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001868s ]