SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415803 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415803 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901439,480914,997810,920640,988333,310635,295323,410182,272291,1015208,756445,768588,947364,705536,18165,768874,548928,1005514,739743,97720,959201,522083,862054,648538,789391,217229,442888,655344,781018,346114,157687,490418,414956,369597,346868,1048288,103316,992447,280425,472465,821470,1019020,143415,782378,335621,777432,136913,274283,697420,932499,132635,750164,797212,422813,92271,26780,187671,560896,364964,224522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]