SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014501 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014501 [ RunTime:0.002269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134317,675642,175409,932984,976125,275055,416567,236830,926688,871885,314811,367571,286629,887710,196463,132958,26957,288416,90242,872378,377975,793517,384802,981238,233624,558879,368418,862705,837205,735390,268959,464526,290416,242402,683444,488598,552217,839451,1018437,638008,233156,809204,500956,54376,574079,252969,854246,12826,667275,274289,949442,848091,1015136,451034,676273,394263,945608,195505,961293,262508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]