SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106126 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106126 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708160,723530,18452,1048267,410296,113257,568725,71097,1014245,725948,241629,1045837,487189,693555,1042955,81683,100007,988697,855101,761911,533934,107646,931035,889248,402367,592391,782995,102282,247516,401414,936880,725624,80860,664660,591447,686072,548340,55075,478015,141194,371585,537403,925050,901948,552366,775793,974305,974379,774456,724989,392146,1004490,303133,696596,399988,578688,93543,728699,276933,1011364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]