SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542623 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542623 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907281,68367,721122,1045344,127759,627109,730050,548862,122913,429844,206131,259979,821327,767630,179187,411600,244192,415721,322061,223171,709845,991758,87917,75550,295152,330565,958109,753279,798870,417533,387699,723444,546051,983136,525031,372031,714072,865535,462875,844867,205157,947649,87023,11058,1003480,527421,815258,707516,223097,313707,855451,950916,35561,890739,997934,281307,309831,614934,450237,132337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]