SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174713 LIMIT 1 [ RunTime:0.002496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174713 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572188,450902,379340,134029,1032490,929945,569640,970687,819572,150468,756650,452506,954158,961963,534135,158166,998454,743745,530224,448831,248949,724179,990462,49636,96481,669959,1039575,726428,591691,669703,911891,462845,312124,543471,79918,726133,601111,372295,390062,449463,780411,591608,395404,438050,922966,1040548,471091,187208,256536,289762,902206,818034,743267,353616,902386,333563,829721,348532,57905,904810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]