SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542741 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542741 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446758,185028,739964,435069,394480,608969,1023593,833456,70054,324665,259163,719203,842001,411145,875361,645174,959005,306520,355240,351856,717553,222369,783677,133370,333272,227661,204399,627231,482756,606482,186362,423985,596818,930360,9470,1025383,291142,315741,577346,1035354,710771,699573,122323,775196,122108,726447,743416,803605,688019,770211,486465,404933,355278,711283,605347,594837,87423,733929,958540,612816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]