SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511967 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511967 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311019,227940,637843,372464,490832,1021129,153095,633611,715283,29011,335487,646132,733993,1010073,838800,592724,544053,237224,134290,518052,216749,355675,573796,94243,477190,289524,980490,701639,495625,687094,219904,462885,611743,342474,856179,341538,670936,210983,16181,137895,376225,424041,438836,419722,1009049,345963,258341,189355,757692,967220,402568,278131,44796,705368,218941,337597,897265,663791,602753,924075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001616s ]