SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547931 LIMIT 1 [ RunTime:0.000835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547931 [ RunTime:0.003211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301631,819188,774563,976231,887616,65566,551851,330525,12038,1038723,260642,843315,864128,753743,141169,914445,654955,802931,70020,686821,904455,168667,746545,429584,69010,1009381,163880,524404,971443,311733,32304,790701,484133,792284,201480,113243,807117,813632,287493,32853,570648,20108,876900,306523,1001804,1007987,273937,673494,190867,872195,226299,559898,615094,673083,937892,360035,590410,448007,129081,773016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]