SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509118 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509118 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594198,393341,757734,772185,15759,848702,753060,251711,697763,231610,444018,384149,1011646,843692,19708,543119,783655,258889,476317,54550,690717,894517,144619,192899,360175,167875,44911,7658,998092,805425,966795,314517,668852,788450,512055,1170,986001,744105,962744,239427,909869,760890,1042301,81639,212875,328125,238930,705641,699582,710769,298946,681956,203004,194175,822448,343333,301676,29132,990107,238355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]