SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450063 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450063 [ RunTime:0.001470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14122,290846,335541,388021,111746,794486,743725,315129,145141,401029,584964,253048,150273,845475,486718,642671,917454,753489,559589,484168,361916,851649,767363,44724,403295,740366,692040,696959,746391,454020,592708,367751,960476,170973,1002219,207436,479740,742295,748974,463612,694860,798196,670520,234536,53676,316255,722616,225768,513607,462672,565313,822977,37760,546459,193206,783610,27284,360338,735017,872430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]